Aggregate - WeekPatternDates

WeekPatternDates Functoid

Some applications make use of an pattern to e.g. determine an schedule for active/non-active weeks. The pattern output exists of 0 (not-active) or 1 (active). This aggregate functoid can be used to create a range of 1's and 0's according to an input list (array) of records.

Inputs with their allowed values:

• Start
  Start date of the period.
• Range
  Mandatory to function is an concat with an '|' as separator and an group function. Please look at the example for the right setup of an range.
• NumOfWeeks
  Number of weeks
• Format
  Date format. Make sure the Start and Range dates are set to the same format!

Note:

• When an empty range is received (the Range only contains |), it will return 0'. The amount is based on the NumOfWeeks value.
• When the Start or End date value is not within the defined range, you will receive a  "'count' must be non-negative." error.

Example: